﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_CYXJ')
            and   type = 'U')
   drop table GXBZ_EMR_CYXJ
go

/*==============================================================*/
/* Table: GXBZ_EMR_CYXJ                                         */
/*==============================================================*/
create table GXBZ_EMR_CYXJ (
   ZYLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   JKKH                 varchar(64)          null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(70)          null,
   CJSJ                 datetime             null,
   WDCJZGH              varchar(64)          null,
   WDCJZXM              varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   ZYYSQMSJ             datetime             null,
   ZYYSGH               varchar(64)          null,
   ZYYSXM               varchar(30)          null,
   SJYSQMSJ             datetime             null,
   SJYSGH               varchar(64)          null,
   SJYSXM               varchar(30)          null,
   NXRDH                varchar(24)          null,
   NXRXM                varchar(30)          null,
   RYRQSJ               datetime             null,
   CYRQSJ               datetime             null,
   BCH                  varchar(20)          null,
   BCHMC                varchar(50)          null,
   BFH                  varchar(20)          null,
   BFHMC                varchar(50)          null,
   KSBM                 varchar(20)          null,
   KSMC                 varchar(50)          null,
   BQBM                 varchar(20)          null,
   BQMC                 varchar(50)          null,
   RYZD                 varchar(1024)        null,
   RXYZDDM              varchar(64)          null,
   RZYBMDM              varchar(64)          null,
   RZYZHDM              varchar(64)          null,
   CXYZDDM              varchar(64)          null,
   CZYBMDM              varchar(64)          null,
   CZYZHDM              varchar(64)          null,
   ZYSZGCJG             varchar(1024)        null,
   CYZD                 varchar(1024)        null,
   CYQK                 varchar(1024         null,
   SSJCZBM              varchar(50)          null,
   SSKSSJ               datetime             null,
   SSQKLBDM             varchar(2)           null,
   YHLBDM               varchar(4)           null,
   YHLBMC               varchar(100)         null,
   MZFFDM               varchar(20)          null,
   SSGCMS               varchar(1024)        null,
   ZZZF                 varchar(100          null,
   ZLGCMS               varchar(1024)        null,
   ZLJGDM               varchar(20)          null,
   SJZYTS               decimal(5)           null,
   ZYJZFF               varchar(100)         null,
   ZYYYFF               varchar(100)         null,
   CYYZ                 varchar(1024)        null,
   YXFZJCJG             varchar(1024)        null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_CYXJ primary key (ZYLSH, XGBZ)
)
go
